package com.orange;

public class Factory {
	// 中国柑橘产量
	public static String view_sql_01 = "create view orange_z_chanliang_year (_VALUE,_SHOW) "
			+ "as select distinct NianFen ,NianFen  "
			+ "from orange_z_chanliang ";
	public static String view_sql_02 = "create view orange_z_chanliang_pro (_VALUE,_SHOW) "
			+ "as select distinct ShengFen,ShengFen  "
			+ "from orange_z_chanliang ";
	// 中国柑橘面积
	public static String view_sql_03 = "create view orange_z_mianji_year (_VALUE,_SHOW) "
			+ "as select distinct NianFen,NianFen  " + "from orange_z_mianji ";
	public static String view_sql_04 = "create view orange_z_mianji_pro (_VALUE,_SHOW) "
			+ "as select distinct ShengFen,ShengFen  "
			+ "from orange_z_mianji ";
	// 中国柑橘进出口
	public static String view_sql_05 = "create view orange_z_jingchuliang_year (_VALUE,_SHOW) "
			+ "as select distinct NianFen,NianFen  "
			+ "from orange_z_jinchuliang ";
	public static String view_sql_06 = "create view orange_z_jingchuliang_bianhao (_VALUE,_SHOW) as select distinct orange_z_jinchuliang.BianHao ,orange_z_jinchuliang.BianHao  from orange_z_jinchuliang";
	// 中国柑橘成本收益
	public static String view_sql_07 = "create view orange_z_jinchuliang_pz (_VALUE,_SHOW) "
			+ "as select distinct Pinzhong,Pinzhong  " + "from orange_z_cbsy ";
	public static String view_sql_08 = "create view orange_z_jinchuliang_year (_VALUE,_SHOW) "
			+ "as select distinct NianFen,NianFen  " + "from orange_z_cbsy ";
	public static String view_sql_09 = "create view orange_z_jinchuliang_pro (_VALUE,_SHOW) "
			+ "as select distinct ShengFen,ShengFen  " + "from orange_z_cbsy ";
	public static String view_sql_10 = "create view orange_z_jinchuliang_cbsy (_VALUE,_SHOW) "
			+ "as select distinct Class,Class  " + "from orange_z_cbsy ";

	// 世界各国柑橘产量与面积
	public static String view_sql_11 = "create view orange_w_c_m_year (_VALUE,_SHOW) "
			+ "as select distinct NianFen,NianFen  "
			+ "from orange_w_changliangandmianji ";
	public static String view_sql_12 = "create view orange_w_c_m_nation (_VALUE,_SHOW) "
			+ "as select distinct GuoJia,GuoJia  "
			+ "from orange_w_changliangandmianji ";
	public static String view_sql_13 = "create view orange_w_c_m_pz (_VALUE,_SHOW) "
			+ "as select distinct PinZhong,PinZhong  "
			+ "from orange_w_changliangandmianji ";

	// 世界各国柑橘贸易
	public static String view_sql_14 = "create view orange_w_trade_year (_VALUE,_SHOW) "
			+ "as select distinct NianFen,NianFen  "
			+ "from orang_w_jinchumaoyi ";
	public static String view_sql_15 = "create view orange_w_trade_export (_VALUE,_SHOW) "
			+ "as select distinct Chu_GuoJia,Chu_GuoJia  "
			+ "from orang_w_jinchumaoyi ";
	public static String view_sql_16 = "create view orange_w_trade_import (_VALUE,_SHOW) "
			+ "as select distinct Jin_GuoJia,Jin_GuoJia  "
			+ "from orang_w_jinchumaoyi ";
	public static String view_sql_17 = "create view orange_w_trade_bianhao (_VALUE,_SHOW) "
			+ "as select distinct BianHao,orange_z_pz.show  "
			+ "from orang_w_jinchumaoyi ,orange_z_pz where orang_w_jinchumaoyi.BianHao=orange_z_pz.value";

	public static String[] views_sql = { view_sql_01, view_sql_02, view_sql_03,
			view_sql_04, view_sql_05, view_sql_06, view_sql_07, view_sql_08,
			view_sql_09, view_sql_10, view_sql_11, view_sql_12, view_sql_13,
			view_sql_14, view_sql_15, view_sql_16, view_sql_17 };

	private String nianfen, chandi;
}
